Incoming/Outgoing Trade Transfers

In this section, incoming and outgoing trade transfers are sorted by asset class, delivered or received and then date.

Field Description
Account ID The account number.
Account Alias Account alias, if there is one.
Model Model, if applicable.
Currency The currency denomination of the trade transfer.
Asset Class The asset class of the trade transfer.
FX Rate to Base The conversion rate from asset currency to base currency.
Symbol The symbol of the trade transfer.
Description The description of the trade transfer.
Conid The conid of the trade transfer.
Security ID The security ID of the trade transfer.
Security ID Type The security ID type of the trade transfer.
CUSIP The CUSIP of the trade transfer.
ISIN The ISIN of the trade transfer.
FIGI The FIGI of the trade transfer.
Underlying Conid The underlying conid of the trade transfer if applicable.
Underlying Symbol The underlying symbol of the trade transfer if applicable.
Issuer The company that issued the contract. For structured products only.
Trade ID The trade ID of the trade transfer.
Report Date The date of the statement.
Trade Date The trade date of the trade transfer.
Trade Time The trade time of the trade transfer.
Settle Date Target The expected settle date of the trade transfer.
Transaction Type The type of transaction.
Exchange The exchange where the transaction took place.
Quantity The number of units for the transaction.
Trade Price The transaction price.
Multiplier The multiplier of the security.
Trade Money Trade money is calculated by multiplying the trade price and quantity.
Proceeds Proceeds can be calculated by multiplying the quantity and the transaction price and adding the away broker's charge(s). The proceeds figure will be positive for incoming trade transfers that are delivered and negative for incoming trade transfers that are received.
Taxes The total amount of tax for the transaction.
IB Commission The total amount of commission for the transaction.
IB Commission Currency The currency denomination of the trade.
Close Price The closing price of the symbol.
Open/Close Indicator The indicator denotes if the trade is an opening or closing trade.
Notes/Close The note/code abbreviation.
Cost Basis The basis of an opening trade is the inverse of proceeds plus commission and tax amount. For closing trades, the basis is the basis of the opening trade.
Realized PNL Realized Profit and Loss can be calculated by the proceeds of the closing trade plus commissions and then adding the basis.
MTM PNL MTM (Mark-to-Market) Profit and Loss can be calculated by taking the difference of the closing and transaction price and multiplying it by quantity and subtracting out the away broker's charge(s).
Original Trade Price The original trade price that was cancelled.
Original Trade Date The original trade date that was cancelled.
Original Trade ID The original trade ID that was cancelled.
Original Order ID The original order ID that was cancelled.
Clearing Firm ID The original clearing firm ID.
Broker Name The name of the broker.
Broker Account The broker account number.
Away Broker Commission The away broker's commission charge.
Regulatory Fee The total regulatory fee.
Direction In or out.
Delivered/Received Delivered or received.
Net Trade Money The net trade money of the trade transfer.
Net Trade Money in Base The net trade money in base currency.
Open Date Time The date and time of the initial trade.
Holding Period Date Time (Wash Sales) If wash sale or closed lot, then the holding period ate and time will display.
When Realized (Wash Sales) The date of the disallowed loss.
When Reopened (Wash Sales) The date when the position was re-opened.
Level of Detail Executions, orders or closed lots.